create proc UpdateTB_Proc
(	@MaTB as nvarchar(10),
	@SBDi	as nvarchar(10),
	@SBDen	as nvarchar(10)
)
	
AS
update tuyenbay set
sanbaydi= @SBDi , sanbayden=@SBDen
where matuyenbay =@MaTB


create proc UpdateCB_Proc
(	@macb as nvarchar(4),
	@matb as nvarchar(10),
	@ngaygio as datetime,
	@khoihanh as datetime,
	@den as datetime,
	@thoigianbay as int,
	@hang1 as int,
	@hang2 as int
)
AS 
update chuyenbay set
matuyenbay =@macb, ngaygio= @ngaygio, khoihanh =@khoihanh,den =@den, thoigianbay = @thoigianbay, slghehang1 = @hang1, slghehang2= @hang2
where machuyenbay = @macb

CREATE PROCEDURE UpdateSB_Proc
(	@masb as nvarchar(3),
	@tensb	as nvarchar(15)
)
	
AS
update SANBAY set
TENSANBAY= @tensb
where MASANBAY =@masb
GO
	
